November 29, 2018

slides > slide.backdrop { background: white; }

Analysis Plan

Analysis Outline

  • Which roadtype are accidents most prone to occur?

  • Which time of day, and day of week are accidents most frequent?

Factors causing traffic accidents

  • Weather, road, light conditions

  • Number of vehicles

  • Government spending on Transportation infrastructure

  • Oil price

Comparisons across major districts

Data Introduction - Primary

  • Name: Road Safety data, 2011-2017
  • Source: Department for Transport
  • Dimension: ~990,000 observations with 32 variables

Key Components:

  • Accident Location: Longitude, Latitude
  • Accident Description: Accident_Severity, Number_of_Vehicles, Number_of_Casualties, Day_of_Week
  • Circumstance: Road_Type, Speed_limit, Light_Conditions, Weather_Conditions, Road_Surface_Conditions

Data Introduction - Secondary

  • Name: Government spending over £25,000 on transportation
  • Source: Office of Rail and road
  • Dimension: ~26,000 observations with 18 variables

Key Components:

-Expense.type, Expense.area, Description, Allocation.Date

Exploration and Result

Geographic Distribution

Major districts:

-Glasgow

-Manchester

-London

-Bristol

These areas will serve as the unit for all our analysis

Road Type

Majority of accidents happen on

-Single carriageway

The central reservation to separate opposing flows of traffic is essential to safety.

Accidents by Months

-Least frequent: February and August

-Gradual decrease in accidents numbers from 2011 to 2017

Time of Accidents

Most accidents occur:

-During weekdays: 8:00-10:00; 16:00-18:00

-During weekends: 12:00-16:00

Time of Accidents

Day of Week of Accidents

Most accidents occur:

  • Tuesday to Friday

  • Gradual increase through the week

Day of Week of Accidents

Weather Condition

Light Condition

Road Condition

Vehicles vs Casualties

-Mostly 1-2 vehicles

-Pile-up is less likely, but more fatal

Government Spending

-The amount of government spending on transportation across districts

Government spending

-Sum the government spending for major districts

-Juxtapose with the number of traffic accidents

Oil Price

-The oil close price from 2012 to 2017

-Positive correlation with daily accidents

Killer Plot

Conclusion

Analysis Synthesis

-Most fatal accidents occur on Single carriageway

-Accidents are least frequent during the holiday season

-Accidents are more likely to happen on weekdays, and during rush hours

-Oil price has a slight positive correlation with daily accidents

-Traffic factors have a strongest impact on accident numbers in London